CREATE PROCEDURE [dbo].[sp_asi_UpdateFullName]
AS
    BEGIN

    -- controls update messages being sent to display
        SET NOCOUNT ON

        SET ROWCOUNT 1000
        DECLARE @isDone BIT
        SET @isDone = 0
        WHILE ( @isDone = 0 )
            BEGIN
                BEGIN TRANSACTION
                UPDATE  Name
                SET     FULL_NAME = dbo.fn_asi_GetFullName(FIRST_NAME,
                                                           MIDDLE_NAME,
                                                           LAST_NAME, PREFIX,
                                                           SUFFIX, DESIGNATION,
                                                           TITLE, INFORMAL)
                WHERE   FULL_NAME <> dbo.fn_asi_GetFullName(FIRST_NAME,
                                                            MIDDLE_NAME,
                                                            LAST_NAME, PREFIX,
                                                            SUFFIX,
                                                            DESIGNATION, TITLE,
                                                            INFORMAL)

                IF @@ROWCOUNT = 0
                    SET @isDone = 1
                COMMIT TRANSACTION
            END
        SET ROWCOUNT 0
    END

GO
GRANT EXECUTE ON  [dbo].[sp_asi_UpdateFullName] TO [IMIS]
GO